{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu principal","TABLA 1","TABLA 2","TABLA 7","TABLA 10","TABLA 12","figuras","materiales","Instrucciones"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu principal","index":0,"n_rows":92,"n_cols":23,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,6,0,7],[91,2,94,7],[83,5,83,7],[80,5,80,7],[81,5,81,7],[82,5,82,7],[2,0,2,7],[12,0,12,7],[18,0,18,7],[58,0,58,7],[47,0,47,7],[82,1,82,4],[75,1,75,4],[76,1,76,4],[83,1,83,4],[67,0,67,7],[73,0,73,7],[16,6,16,7],[79,0,79,7],[80,1,80,4],[1,0,1,7],[50,6,50,7],[49,6,49,7],[15,6,15,7],[36,0,36,7],[63,0,63,7],[42,0,42,7],[51,0,51,7]]}
[null,null,null,null,null,null,"Diseñado por Ing. Gregor Rojas\nCaracas - Venezuela"]
["PROGRAMA DE CÁLCULO DE LA MALLA DE PUESTA A TIERRA \nBASADO EN LA IEEE 80-2000"]
["DATOS PARA EL CÁLCULO DE LA MALLA DE PUESTA A TIERRA"]
[null,"Instructivo de uso del programa"]
[null,"Resistencia requerida según aplicación menor a (W)",null,null,null,{"$f":"IF(U5=1,$T$6,IF(U5=2,$T$7,$T$8))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"",1]
["ρ","Resistividad aparente del terreno   (Ω.m)",null,null,null,{"$f":"S6","v":10},null,null,null,null,null,null,null,null,null,null,null,null,10,1,"Subestaciones de alta y extra alta tensión"]
["If","Corriente de falla a tierra simétrica rms (A)",null,null,null,{"$f":"$S$9","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Subestaciones de media tensión"]
["tc","Tiempo de despeje de la falla (ms)",null,null,null,{"$f":"S8","v":50},null,null,null,null,null,null,null,null,null,null,null,null,50,20,"Estructuras de líneas de transmisión"]
[null,"Marque la casilla si existe una capa superficial",null,null,null,{"$f":"IF($U$9=TRUE,$W$9,$W$10)","v":"SI"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$T$9*2","v":1000},500,true,null,"SI"]
["ρs","Resistividad de la capa superficial  (Ω.m) Ver tabla 7",null,null,null,{"$f":"IF($U$9=TRUE,$T$10,$F$6)","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*$U$10","v":100},50,null,"NO"]
["hs","Espesor de la capa superficial  hs (cm)",null,null,null,{"$f":"S11","v":5},null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Recuerde borrar operaciones anteriores para reiniciar cálculos"]
["CARACTERISTICAS DEL CONDUCTOR DE LA MALLA DE PAT"]
[null,"Tipo de conductor seleccionado",null,null,null,null,{"$f":"U14","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Kf","Constante del material conductor a utilizar en la PAT",null,null,null,{"$f":"'TABLA 2'!E52","v":7},"Tabla 2 Pag. 44 IEEE 80-2000"]
["Amm2","Área calculada del conductor a utilizar en la malla (mm2)",null,null,null,{"$f":"((($F$7/1000)*$F$15*SQRT($F$8/1000)))/1.974","v":0.79293190691481907},"Formula 40 Y 41 Pag. 43 IEEE 80-2000"]
["d","Diámetro del conductor a utilizar en la malla de PAT (mm)",null,null,null,{"$f":"IF($F$18=\"2/0 AWG\",materiales!$F$10,IF($F$18=\"3/0 AWG\",materiales!$F$11,IF($F$18=\"4/0 AWG\",materiales!$F$12,IF($F$18=\"250Kcmil\",materiales!$F$13,IF($F$18=\"300Kcmil\",materiales!$F$14,IF($F$18=\"350Kcmil\",materiales!$F$15,materiales!$F$16))))))","v":10.63},"Por requerimientos mecánicos"]
[null,"Calibre conductor a utilizar en malla de puesta a tierra",null,null,null,{"$f":"IF($F$16<materiales!G10,\"2/0 AWG\",IF($F$16<materiales!G11,\"3/0 AWG\",IF($F$16<materiales!G12,\"4/0 AWG\",IF($F$16<materiales!G13,\"250Kcmil\",IF($F$16<materiales!G14,\"300Kcmil\",IF($F$16<materiales!G15,\"350Kcmil\",IF($F$16<materiales!G16,\"500Kcmil\",\"Revisar\")))))))","v":"2/0 AWG"},"Código GEDISA",{"$f":"IF($F$16<materiales!$G$10,materiales!$B$10,IF($F$16<materiales!$G$11,materiales!$B$11,IF($F$16<materiales!$G$12,materiales!$B$12,IF($F$16<materiales!$G$13,materiales!$B$13,IF($F$16<materiales!$G$14,materiales!$B$14,IF($F$16<materiales!$G$15,materiales!$B$15,IF($F$16<materiales!$G$16,materiales!$B$16,\"REPLANTEAR\")))))))","v":"CBDES0100200"}]
["GEOMETRIA DE LA MALLA"]
["a","Cuadrada",null,null,"Largo (m)",{"$f":"T20","v":5},3,null,null,null,null,null,null,null,null,null,null,null,null,5]
["b","Rectangular",null,null,"Ancho (m)",{"$f":"IF(G20=1,F20,IF(G20=2,G21,IF(G20=3,G21,G21)))","v":5},5]
["L1","En forma de L",null,null,"L1 (m)",{"$f":"IF(G20=1,0,IF(G20=2,0,G22))","v":3},3]
["L2",null,null,null,"L2 (m)",{"$f":"IF(G20=1,0,IF(G20=2,0,G23))","v":3},3]
["D","Longitud de los lados de la cuadrícula (m)",null,null,null,{"$f":"T24","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["h","Profundidad de enterramiento de la malla (cm)",null,null,null,{"$f":"T25","v":30},{"$f":"F20*F21","v":25},null,null,null,null,null,null,null,null,null,null,null,null,30]
["A","Área  de la malla de PAT (m2)",null,null,null,{"$f":"IF(G20=1,G25,IF(G20=2,G25,(F20*F22)+F23*(F21-F22)))","v":21},{"$f":"ROUNDUP(($F$28-2)*($F$30-2),0)","v":16},{"$f":"ROUNDUP(($F$28-2)*($F$30-2)-(($F$20-$F$22)/$F$24)*(($F$21-$F$23)/$F$24),0)","v":12}]
["Lp","Longitud del perímetro (m)",null,null,null,{"$f":"(F20+F21)*2","v":20}]
[null,"Número de conductores en el sentido longitudinal o \"X\" ",null,null,null,{"$f":"((F20/F24)+1)","v":6}]
["Lx","Longitud  Máxima del Conductor en el sentido de \"X\" (m)",null,null,null,{"$f":"(F20*(F20+F24-F22)+F22*(F22-F24))/F24","v":21}]
[null,"Número de conductores en el sentido transversal o \"Y\"",null,null,null,{"$f":"(F21/F24)+1","v":6}]
["Ly","Longitud  Máxima del Conductor en el sentido de \"Y\" (m)",null,null,null,{"$f":"(F21*(F21+F24-F23)+F23*(F23-F24))/F24","v":21},null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"SI"]
["LC","Longitud  Conductor Horizontal De La Malla (m)",null,null,null,{"$f":"F29+F31","v":42},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"NO"]
[null,"Empleo de barras copperweld o jabalinas",null,null,null,{"$f":"IF($U$31=TRUE,$W$31,$W$32)","v":"NO"}]
[null,"Modelo de barra copperweld",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["dr","Diámetro de la Barra Copperweld o jabalina (mm)",null,null,null,{"$f":"IF($U$31=TRUE,G35,\"0\")","v":"0"},{"$f":"IF($U$34=1,$T$35,IF($U$34=2,$T$36,$T$37))","v":14.2875},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(25.4*9/16)","v":14.2875},"Barra copperweld de 9/16\""]
["Lr","Longitud de la Barra Copperweld o jabalina (m)",null,null,null,{"$f":"IF($U$31=TRUE,G36,\"0\")","v":"0"},{"$f":"H36/100","v":2.4},240,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(25.4*5/8)","v":15.875},"Barra copperweld de 5/8\""]
["GEOMETRIA DE LA MALLA CONTINUACION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(25.4*3/4)","v":19.049999999999997},"Barra copperweld de 3/4\""]
["nR","Número de barras copperweld colocadas en el área A",null,null,null,{"$f":"IF($U$31=TRUE,$G$38,\"0\")","v":"0"},1]
["LR","Longitud total de las Barras Copperweld o Jabalinas (m)",null,null,null,{"$f":"IF($U$31=TRUE,$F$38*$F$36,\"0\")","v":"0"}]
["LM","Longitud efectiva sin barras o con ellas no ubicadas en esquinas (m)",null,null,null,{"$f":"$F$32+$F$39","v":42},"Formula 90 Pag. 94 IEEE 80-2000"]
["LM","Longitud efectiva con barras en el perímetro y esquinas (m)",null,null,null,{"$f":"$F$32+(1.55+1.22*($F$36/SQRT((F29^2)+($F$31^2))))*$F$39","v":42},"Formula 91 Pag. 94 IEEE 80-2000"]
["LS","Longitud efectiva con barras copperweld o sin ellas (m)",null,null,null,{"$f":"0.75*F32+0.85*F39","v":31.5},"Formula 93 Pag. 94 IEEE 80-2000"]
["MOLDES Y CARTUCHOS PARA SOLDADURA EXOTERMICA"]
["CX","Cantidad de conexiones exotérmicas en EQUIS",null,null,null,{"$f":"IF($G$20=1,$G$26,IF($G$20=2,$G$26,IF($G$20=3,$H$26,$H$26)))","v":12},"Código GEDISA",{"$f":"IF($F$18=\"2 AWG\",materiales!B25,IF($F$18=\"1/0 AWG\",materiales!B27,IF($F$18=\"2/0 AWG\",materiales!B28,IF($F$18=\"3/0 AWG\",materiales!B29,IF($F$18=\"4/0 AWG\",materiales!B29,IF($F$18=\"250Kcmil\",materiales!B27,IF($F$18=\"300Kcmil\",materiales!B28,IF($F$18=\"350Kcmli\",materiales!B29,IF($F$18=\"500Kcmil\",REVISAR,\"REPLANTEAR\")))))))))","v":"PTCE000200"}]
["MX","Molde de grafito para conexión exotérmica en EQUIS",null,null,null,{"$f":"ROUNDUP(($F$44/40),0)","v":1},"Código GEDISA",{"$f":"IF($F$18=\"2 AWG\",materiales!B33,IF($F$18=\"1/0 AWG\",materiales!B34,IF($F$18=\"2/0 AWG\",materiales!B35,IF($F$18=\"3/0 AWG\",materiales!B36,IF($F$18=\"4/0 AWG\",materiales!B37,IF($F$18=\"250Kcmil\",materiales!B38,IF($F$18=\"300Kcmil\",materiales!B39,IF($F$18=\"350Kcmli\",materiales!B40,IF($F$18=\"500Kcmil\",REVISAR,\"REPLANTEAR\")))))))))","v":"PTXSH070070"}]
["CT","Cantidad de conexiones exotérmicas en TEE",null,null,null,{"$f":"ROUNDUP(2*($F$28-2)+2*($F$30-2),0)+4","v":20},"Código GEDISA",{"$f":"IF($F$18=\"2 AWG\",materiales!B22,IF($F$18=\"1/0 AWG\",materiales!B25,IF($F$18=\"2/0 AWG\",materiales!B25,IF($F$18=\"3/0 AWG\",materiales!B26,IF($F$18=\"4/0 AWG\",materiales!B27,IF($F$18=\"250Kcmil\",materiales!B27,IF($F$18=\"300Kcmil\",materiales!B28,IF($F$18=\"350Kcmli\",materiales!B28,IF($F$18=\"500Kcmil\",REVISAR,\"REPLANTEAR\")))))))))","v":"PTCE000090"}]
["MT","Molde de grafito para conexión exotérmica en TEE",null,null,null,{"$f":"ROUNDUP(($F$46/40),0)","v":1},"Código GEDISA",{"$f":"IF($F$18=\"2 AWG\",materiales!B43,IF($F$18=\"1/0 AWG\",materiales!B44,IF($F$18=\"2/0 AWG\",materiales!B45,IF($F$18=\"3/0 AWG\",materiales!B46,IF($F$18=\"4/0 AWG\",materiales!B47,IF($F$18=\"250Kcmil\",materiales!B48,IF($F$18=\"300Kcmil\",materiales!B49,IF($F$18=\"350Kcmli\",materiales!B50,IF($F$18=\"500Kcmil\",REVISAR,\"REPLANTEAR\")))))))))","v":"PTCTH070070"}]
["CÁLCULO DE RESISTENCIA DE PUESTA A TIERRA"]
["Rm","Resistencia de malla (W)",null,null,null,{"$f":"$F$6*((1/($F$32+$F$39))+(1/SQRT(20*$F$26))*(1+(1/(1+($F$25/100)*SQRT(20/$F$26)))))","v":1.1034906269632339},"Formula 52 Pag. 65 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,"p((1/LT)+ (1/raiz20A)*(1 + (1/(1+hraiz(20/A))))",null,null,{"$f":"IF($U$34=1,\"Barra copperweld 9/16\",IF($U$34=2,\"Barra copperweld 5/8\",\"Barra copperweld 3/4\"))","v":"Barra copperweld 9/16"}]
["Rr","Resistencia de la barra copperweld seleccionada (W)",null,null,null,{"$f":"IF($U$31=TRUE,$T$50,\"0\")","v":"0"},{"$f":"IF($U$31=TRUE,$U$49,$U$51)","v":"Sin barras copperweld"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($F$6/(2*3.14*$F$36))*LN((8*$F$36/($F$35/100))-1)","v":{"$error":"#DIV/0!"}},"Con barras copperweld"]
["Rg","Resistencia equivalente del sistema de PAT (W)",null,null,null,{"$f":"IF($U$31=TRUE,$T$51,$F$49)","v":1.1034906269632339},{"$f":"IF($U$31=TRUE,$U$50,$U$51)","v":"Sin barras copperweld"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/(((1/$F$50)*$F$38)+(1/$F$49))","v":{"$error":"#DIV/0!"}},"Sin barras copperweld"]
["CÁLCULO DE CORRIENTE MAXIMA DE MALLA"]
["IG","Máxima corriente de malla (A)",null,null,null,{"$f":"$F$55*$F$54","v":258.71999999999997},"Formula 63 Y 64 Pag. 73 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,null,null,"IG=","Df*Ig","Df*(Sf*3I0)"]
["Ig","Corriente de malla simétrica rms (A)",null,null,null,{"$f":"$F$58*$F$7","v":210},"Formula 65 Pag. 73 IEEE 80-2000"]
["Df","Factor de decremento para la determinación de IG",null,null,null,{"$f":"INDEX('TABLA 10'!C4:F12,'Menu principal'!U56,'Menu principal'!U57)","v":1.232},"Formula 79 Pag. 84 IEEE 80-2000"]
["X/R","Valores típicos de la Relación X/R",null,null,null,null,"Tabla 10 Pag. 85 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["tf","Valores típicos del Tiempo de duración de la falla (Seg)",null,null,null,null,"Tabla 10 Pag. 85 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Sf","Factor divisor de la corriente de falla",null,null,null,0.21,"Formula 63 Pag. 72 IEEE 80-2000"]
["CÁLCULO DE VOLTAJES PERMISIBLES DE PASO Y TOQUE"]
[null,"Peso de la persona para estimación"]
["Ep","Voltaje de paso tolerable (V)",null,null,null,{"$f":"IF(U61=1,(1000+6*$F$63*$F$10)*0.116/SQRT($F$8/1000),(1000+6*$F$63*$F$10)*0.157/SQRT($F$8/1000))","v":943.80427945464294},"Formula 29 y 30  Pag. 27 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,"(1000+6Cs*ps)*0,157 / raíz(ts)",null,null,2]
["Et","Voltaje de toque tolerable (V)",null,null,null,{"$f":"IF(U61=1,(1000+1.5*$F$63*$F$10)*0.116/SQRT($F$8/1000),(1000+1.5*$F$63*$F$10)*0.157/SQRT($F$8/1000))","v":762.54507856486111},"Formula 32 y 33  Pag. 27 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,"(1000+1,5Cs*ps)*0,157 / raíz(ts)",null,null,"Persona de 50 kg"]
["Cs","Factor de decremento de la capa superficial",null,null,null,{"$f":"1-(0.09*(1-($F$6/$F$10))/((2*$F$11/100)+0.09))","v":0.5736842105263158},"Formula 27 Pag. 23 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,"1-((0,09*(1-p/ps))/(2*hs+0,09))",null,null,"Persona de 70 kg"]
["CÁLCULO DE VOLTAJES MAXIMOS DE PASO Y TOQUE "]
["GPR","Máxima elevación del potencial de tierra GPR (V)",null,null,null,{"$f":"$F$51*$F$53","v":285.49509500792783}]
["Em","Voltaje de malla en caso de falla (V)",null,null,null,{"$f":"$F$6*$F$75*$F$78*$F$53/$F$41","v":44.509415676298175},"Formula 80 Pag. 91 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,"ρ*Km*Ki*IG / LM"]
["Es","Voltaje de paso en caso de falla (V)",null,null,null,{"$f":"$F$6*$F$79*$F$78*$F$53/$F$42","v":117.48175099355014},"Formula 92 Pag. 94 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,"ρ*Ks*Ki*IG / Ls"]
["CÁLCULO DE FACTORES GEOMETRICOS"]
["n","Factor geométrico compuesto de factores: na, nb, nc y nd",null,null,null,{"$f":"F70*F71*F72*F73","v":4.8557178725358687},"Formula 84 Pag. 93 IEEE 80-2000"]
["na","Factor geométrico ",null,null,null,{"$f":"2*$F$32/$F$27","v":4.2},"Formula 85 Pag. 93 IEEE 80-2000"]
["nb","Factor geométrico ",null,null,null,{"$f":"IF($G$20=1,1,IF($G$20=2,(SQRT($F$27/(4*SQRT($F$26)))),(SQRT($F$27/(4*SQRT($F$26))))))","v":1.0445522730720382},"Formula 86 Pag. 93 IEEE 80-2000"]
["nc","Factor geométrico ",null,null,null,{"$f":"IF($G$20=1,1,IF($G$20=2,1,($F$29*$F$31/$F$26)^(0.7*$F$26/($F$29*$F$31))))","v":1.1068122991916536},"Formula 87 Pag. 93 IEEE 80-2000"]
["nd","Factor geométrico ",null,null,null,{"$f":"IF($G$20=1,1,IF($G$20=2,1,(1)))","v":1},"Formula 88 Pag. 93 IEEE 80-2000"]
["CÁLCULO DE FACTORES CORRECCION"]
["Km","Factor de separación para el voltaje de la malla",null,null,null,{"$f":"(1/(2*3.14))*((LN((($F$24^2/(16*($F$17/1000)*($F$25/100))))+($F$24+2*($F$25/100))^2/(8*$F$24*($F$17/1000))-($F$25/100)/(4*($F$17/1000))))+($F$76/$F$77)*LN(8/(PI()*((2*$F$69)-1))))","v":0.53025901026777966},"Formula 81 Pag. 93 IEEE 80-2000",null,null,null,null,null,null,null,null,null,null,{"$f":"(1/(2*3.14))*(LN(($F$24^2/(16*($F$17/1000)*($F$25/100))))+($F$24+2*($F$25/100))^2/(8*$F$24*($F$17/1000))-($F$25/100)/(4*($F$17/1000)))+($F$76/$F$77)*LN(8/(PI()*((2*$F$69)-1)))","v":3.7209384165671398}]
["Kii","Factor de ponderación correctiva que se ajusta a los efectos de los conductores internos en la esquina de la malla",null,null,null,{"$f":"IF($H$38=TRUE,1,(1/(2*$F$69)^(2/$F$69)))","v":0.39205971717405297},"Formula 82 Pag. 93 IEEE 80-2000"]
["Kh","Factor de ponderación correctiva que hace hincapié en los efectos de la profundidad de la red",null,null,null,{"$f":"SQRT(1+$F$25/100)","v":1.1401754250991381},"Formula 83 Pag. 93 IEEE 80-2000"]
["Ki","Factor de corrección por geometría de la malla",null,null,null,{"$f":"0.644+0.148*$F$69","v":1.3626462451353085},"Formula 89 Pag. 94 IEEE 80-2000"]
["Ks","Factor de separación para el voltaje de paso",null,null,null,{"$f":"(1/PI())*((1/(2*$F$25/100))+(1/($F$24+$F$25/100))+(1/$F$24)*(1-0.5^($F$69-2)))","v":1.0497063833541669},"Formula 94 Pag. 94 IEEE 80-2000"]
["EVALUACION DE RESULTADOS"]
[1,"¿La resistencia de puesta a tierra Rg obtenida es menor que la resistencia requerida?",null,null,null,{"$f":"IF($F$51<$F$5+0.1,\"Sí, el diseño cumple con el requerimiento\",\"No, el diseño no cumple con el requerimiento, ¡MODIFICAR SU DISEÑO!\")","v":"No, el diseño no cumple con el requerimiento, ¡MODIFICAR SU DISEÑO!"}]
[2,"¿Es GPR menor que el voltaje de contacto tolerable?",null,null,null,{"$f":"IF(F65<F62,\"Sí, el diseño cumple con el requerimiento\",\"Verifique el voltaje de malla (Em)\")","v":"Sí, el diseño cumple con el requerimiento"}]
[3,"Bajo condiciones de falla, ¿Es el voltaje de malla (Em) menor que el voltaje de contacto tolerable (Et)?",null,null,null,{"$f":"IF(F66<F62,\"Sí, el voltaje de malla cumple con el requerimiento\",\"NO, REPLANTEAR DISEÑO\")","v":"Sí, el voltaje de malla cumple con el requerimiento"},null,null,null,null,null,null,null,null,null,null,null,"F61<F57"]
[4,"Bajo condiciones de falla ¿Es el voltaje de paso (Es) menor que el voltaje de paso tolerable (Ep)?",null,null,null,{"$f":"IF(F83=\"Sí, el voltaje de malla cumple con el requerimiento\",IF(F67<F61,\"Sí, el voltaje de paso cumple con el requerimiento\",\"NO, el voltaje de paso no cumple con norma, Modificar diseño\"),\"REPLANTEAR TODO EL DISEÑO\")","v":"Sí, el voltaje de paso cumple con el requerimiento"},null,null,null,null,null,null,null,null,null,null,null,"F62<F56"]
[]
[null,null,null,null,null,null,null,"Agradesco cualquier sugerencia para mejorar este programa"]
[null,null,null,null,null,null,null," enviandola a gregorrojas@gedisa.com.ve"]
[]
[]
[]
[]
[null,null,"Descarga desde www.gedisa.com.ve el manual de sistemas de puesta a tierra GEDIWELD donde encontraras todos los materiales referidos a puesta a tierra"]

{"sheet":"TABLA 1","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["TABLE 1 IEEE 80-2000 \nMATERIAL CONSTANTS"]
["Description","Material conductivity (%)","αr factor \nat 20 °C\n(1/°C)","Ko at 0 °C \n(0 °C)","Fusinga temperature Tm\n(°C)","ρr 20 °C\n(µΩ·cm)","TCAP thermal capacity [J/(cm3·°C)]"]
["Copper, annealed soft-drawn",100,3.9300000000000003E-3,234,1083,1.72,3.42]
["Copper, commercial hard-drawn",97,3.81E-3,242,1084,1.78,3.42]
["Copper-clad steel wire",40,3.7799999999999999E-3,245,1084,4.4000000000000004,3.85,null,null,"i",20]
["Copper-clad steel wire",30,3.7799999999999999E-3,245,1084,5.86,3.85,null,null,"tc",3]
["Copper-clad steel rodb",20,3.7799999999999999E-3,245,1084,8.6199999999999992,3.85]
["Aluminum, EC grade",61,4.0299999999999997E-3,228,657,2.86,2.56]
["Aluminum, 5005 alloy",53.5,3.5300000000000002E-3,263,652,3.22,2.6,null,null,{"$f":"K5","v":20},{"$f":"K5","v":20}]
["Aluminum, 6201 alloy",52.5,3.47E-3,268,654,3.28,2.6,null,1,{"$f":"(G6/10000)/(K6*C6*F6)","v":5.7936206969199013E-3},{"$f":"(G6)/(K6*C6*F6)","v":57.936206969199013}]
["Aluminum-clad steel wire",20.3,3.5999999999999999E-3,258,657,8.48,3.58,null,null,{"$f":"(D6+E6)/(D6+40)","v":4.6631578947368419},{"$f":"(D6+E6)/(D6+40)","v":4.6631578947368419}]
["Steel, 1020",10.8,1.6000000000000001E-3,605,1510,15.9,3.28,null,2,{"$f":"LN(J11)","v":1.5396928784445947},{"$f":"LN(K11)","v":1.5396928784445947}]
["Stainless-clad steel rodc",9.8000000000000007,1.6000000000000001E-3,605,1400,17.5,4.4400000000000004,null,null,{"$f":"SQRT(J10*J12)","v":9.4447850835563119E-2},{"$f":"SQRT(K10*K12)","v":9.4447850835563116}]
["Zinc-coated steel rod",8.6,3.2000000000000002E-3,293,419,20.100000000000001,3.93,null,null,{"$f":"J9/J13","v":211.75706829815186},{"$f":"K9*197.4/K13","v":418.00845282055184}]
["Stainless steel, 304",2.4,1.2999999999999999E-3,749,1400,72,4.03]
["a From ASTM standards."]
["b Copper-clad steel rods based on 0.254 mm (0.010 in) copper thickness."]
["c Stainless-clad steel rod based on 0.508 mm (0.020 in) No. 304 stainless steel thickness over No. 1020 steel core."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Agradezco cualquier sugerencia para mejorar este programa"]
[null,null,null,null,null,null,"Gregor Rojas"]

{"sheet":"TABLA 2","index":2,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,7]]}
["TABLE 2 IEEE 80-2000 \nMATERIAL CONSTANTS",null,null,null,"TABLA 2 IEEE 80-2000 \nCONSTANTES DE MATERIALES"]
["Material","Conductivity (%)","Tm  a (°C)","Kf","Material","Conductividad (%)","Tm  a (°C)","Kf"]
["Copper, annealed soft-drawn",100,1083,7,"Cobre blando, recocido suave",100,1083,7]
["Copper, commercial hard-drawn",97,1084,7.06,"Cobre duro comercial, cuando se utiliza solddura exotérmica",97,1084,7.06]
["Copper, commercial hard-drawn",97,250,11.78,"Cobre duro comercial, cuando se utilizan conexiones mecánicas a presión",97,250,11.78]
["Copper-clad steel wire",40,1084,10.45,"Alambre de acero revestido de cobre ",40,1084,10.45]
["Copper-clad steel wire",30,1084,12.06,"Alambre de acero revestido de cobre ",30,1084,12.06]
["Copper-clad steel rod",20,1084,14.64,"Varilla de acero revestido de cobre ",20,1084,14.64]
["Aluminum EC Grade",61,657,12.12,"Aluminio CE Grado ",61,657,12.12]
["Aluminum 5005 Alloy",53.5,652,12.41,"Aluminio 5005 Aleación ",53.5,652,12.41]
["Aluminum 6201 Alloy",52.5,654,12.47,"Aluminio 6201 Aleación ",52.5,654,12.47]
["Aluminum-clad steel wire",20.3,657,17.2,"Alambre de acero revestido de aluminio ",20.3,657,17.2]
["Steel 1020",10.8,1510,15.95,"acero 1020 ",10.8,1510,15.95]
["Stainless clad steel rod",9.8000000000000007,1400,14.72,"Varilla de acero revestido en acero inoxidable",9.8000000000000007,1400,14.72]
["Zinc-coated steel rod",8.6,419,28.96,"Varilla de acero galvanizado ",8.6,419,28.96]
["Stainless steel 304",2.4,1400,30.05,"Acero inoxidable 304",2.4,1400,30.05]
["a See 11.3.3 for comments concerning material selection.",null,null,null,"a See 11.3.3 for comments concerning material selection."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Agradezco cualquier sugerencia para mejorar este programa"]
[null,null,null,null,null,null,null,"Gregor Rojas"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"'Menu principal'!U14","v":1}]
[null,null,null,null,{"$f":"IF(F51=1,H3,IF(F51=2,H4,IF(F51=3,H5,IF(F51=4,H6,IF(F51=5,H7,IF(F51=6,H8,IF(F51=7,H9,IF(F51=8,H10,IF(F51=9,H11,IF(F51=10,H12,IF(F51=11,H13,IF(F51=12,H14,IF(F51=13,H14,IF(F51=14,H16,\"Seleccione un material\"))))))))))))))","v":7}]

{"sheet":"TABLA 7","index":3,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[1,2,1,3],[0,0,0,3]]}
["TABLE 7 IEEE 80-2000 \nTYPICAL SURFACE MATERIAL RESISTIVITIES"]
["Number","Description of surface material\n(U.S. state where found)","Resistivity of sample Ω·m"]
[null,null,"Dry","Wet"]
[1,"Crusher run granite with fines\n(N.C.)","140 × 106","1300 (ground water, 45 Ω·m)"]
[2,"1.5 in (0.04 m) crusher run granite (Ga.) with fines",4000,"1200 (rain water, 100 W)"]
[3,"0.75–1 in (0.02–0.025 m) granite (Calif.) with fines","—","6513 (10 min after 45 Ω·m water drained)"]
[4,"#4 (1 -2 in) (0.025-0.05 m) washed granite (Ga.)","1.5 × 106 to 4.5 × 106","5000 (rain water, 100 Ω·m)"]
[5,"#3 (2–4 in) (0.05-0.1 m) washed granite (Ga.)","2.6 × 106 to 3 × 106","10 000 (Rain water, 100 Ω·m)"]
[6,"Size unknown, washed limestone (Mich.)","7 × 106","2000–3000 (ground water, 45 Ω·m)"]
[7,"Washed granite, similar to 0.75 in (0.02 m) gravel","2× 106",10000]
[8,"Washed granite, similar to pea gravel","40× 106",5000]
[9,"#57 (0.75 in) (0.02 m) washed granite (N.C.)","190× 106","8000 (ground water, 45 Ω·m)"]
[10,"Asphalt","2 × 106 to 30 × 106","10 000 to 6 × 106"]
[11,"Concrete","1 × 106 to 1 × 109a","21 to 100"]
["aOven dried concrete (Hammond and Robson [B78]). Values for air-cured concrete can be much lower due to moisture content"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Agradezco cualquier sugerencia para mejorar este programa"]
[null,null,null,"Gregor Rojas"]

{"sheet":"TABLA 10","index":4,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,2,1,5],[0,0,0,5]]}
["TABLE 10 IEEE 80-2000 \nTYPICAL VALUES OF Df"]
["Fault duration, tf",null,"Decrement factor, Df"]
["Seconds","Cycles at 60 Hz","X/R = 10","X/R = 20","X/R = 30","X/R = 40"]
["0.00833",0.5,1.5760000000000001,1.6479999999999999,1.675,1.6879999999999999,null,null,null,null,null,null,{"$f":"A4&\" seg\"","v":"0.00833 seg"},"X/R = 10"]
[0.05,3,1.232,1.3779999999999999,1.462,1.5149999999999999,null,null,null,null,null,null,{"$f":"A5&\" seg\"","v":"0,05 seg"},"X/R = 20"]
[0.1,6,1.125,1.232,1.3160000000000001,1.3779999999999999,null,null,null,null,null,null,"0,1 seg","X/R = 30"]
[0.2,12,1.0640000000000001,1.125,1.181,1.232,null,null,null,null,null,null,"0,2 seg","X/R = 40"]
[0.3,18,1.0429999999999999,1.085,1.125,1.163,null,null,null,null,null,null,"0,3 seg"]
[0.4,24,1.0329999999999999,1.0640000000000001,1.095,1.125,null,null,null,null,null,null,"0,4 seg"]
[0.5,30,1.026,1.052,1.077,1.101,null,null,null,null,null,null,"0,5 seg"]
[0.75,45,1.018,1.0349999999999999,1.052,1.0680000000000001,null,null,null,null,null,null,"0,75 seg"]
[1,60,1.0129999999999999,1.026,1.0389999999999999,1.052,null,null,null,null,null,null,"1 seg"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Agradezco cualquier sugerencia para mejorar este programa"]
[null,null,null,null,null,"Gregor Rojas"]

{"sheet":"TABLA 12","index":5,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,5]]}
["TABLE 12 IEEE 80-2000 \nINDEX OF DESIGN PARAMETERS",null,null,"TABLA 12 IEEE 80-2000 \nINDICE DE PARAMETROS PARA DISEÑO"]
["Symbol","Description","Clause \nnumber","Simbolo","Descripción","Número de sección"]
["ρ","Soil resistivity, Ω·m","Clause 13","ρ","Resistividad del suelo, Ω · m ","Clause 13"]
["ρs","Surface layer resistivity, Ω·m","7.4, 12.5","ρs","Resistividad de la capa superficie, Ω · m ","7.4, 12.5"]
["3I0","Symmetrical fault current in substation for conductor sizing, A",15.3,"3I0","Corriente de falla simétrica en la subestación para el dimensionamiento del conductor, A ",15.3]
["A","Total area enclosed by ground grid, m2",14.2,"A","Area total encerrada por malla de tierra, m2 ",14.2]
["Cs","Surface layer derating factor",7.4,"Cs","Factor de reducción de la capa superficial ",7.4]
["d","Diameter of grid conductor, m",16.5,"d","Diámetro del conductor de malla, m ",16.5]
["D","Spacing between parallel conductors, m",16.5,"D","Distancia entre conductores paralelos, m ",16.5]
["Df","Decrement factor for determining IG","15.1.4, 15.10","Df","Factor de decremento para determinar IG ","15.1.4, 15.10"]
["Dm","Maximum distance between any two points on the grid, m",16.5,"Dm","Distancia máxima entre dos puntos cualesquiera de la malla, m ",16.5]
["Em","Mesh voltage at the center of the corner mesh for the simplified method, V",16.5,"Em","Voltaje de malla en el centro de la malla de la esquina para el método simplificado, V ",16.5]
["Es","Step voltage between a point above the outer corner of the grid and a point 1 m diagonally outside the grid for the simplified method, V",16.5,"Es","Tensión de paso entre un punto por encima de la esquina exterior de la malla y un punto a 1 m en diagonal fuera de la malla para el método simplificado, V ",16.5]
["Estep50","Tolerable step voltage for human with 50 kg body weight, V",8.3000000000000007,"Estep50","Tensión de paso tolerable para personas con 50 kg de peso corporal, V ",8.3000000000000007]
["Estep70","Tolerable step voltage for human with 70 kg body weight, V",8.3000000000000007,"Estep70","Tensión de paso tolerable para personas con 70 kg de peso corporal, V ",8.3000000000000007]
["Etouch50","Tolerable touch voltage for human with  50 kg body weight, V",8.3000000000000007,"Etouch50","Tensión de contacto tolerable para personas con 50 kg de peso corporal, V ",8.3000000000000007]
["Etouch70","Tolerable touch voltage for human with  70 kg body weight, V",8.3000000000000007,"Etouch70","Tensión de contacto tolerable para personas con 70 kg de peso corporal, V ",8.3000000000000007]
["h","Depth of ground grid conductors, m",14.2,"h","Profundidad en el suelo del conductor de malla, m ",14.2]
["hs","Surface layer thickness, m",7.4,"hs","Espesor de la capa superficial, m ",7.4]
["IG","Maximum grid current that flows between ground grid and surrounding earth (including dc offset), A","15.1.4","IG","Corriente de malla máxima que fluye entre la malla de tierra y la tierra circundante (incluyendo el desplazamiento DC)","15.1.4"]
["Ig","Symmetrical grid current, A","15.1.6","Ig","Corriente de malla simétrica, A ","15.1.6"]
["K","Reflection factor between different resistivities",7.4,"K","Factor de reflexión entre las diferentes resistividades ",7.4]
["Kh","Corrective weighting factor that emphasizes the effects of grid depth, simplified method",16.5,"Kh","Factor de ponderación correctiva que hace hincapié en los efectos de profundidad de la malla, método simplificado ",16.5]
["Ki","Correction factor for grid geometry, simplified method",16.5,"Ki","Factor de corrección de la geometría de la malla, metodo simplificado",16.5]
["Kii","Corrective weighting factor that adjusts for the effects of inner conductors on the corner mesh, simplified method",16.5,"Kii","Factor de ponderación correctiva que se ajusta por los efectos de intrinsicos del conductor en las esquimas de la malla, método simplificado ",16.5]
["Km","Spacing factor for mesh voltage,",16.5,"Km","Factor de espaciado para la tensión de malla, ",16.5]
["Ks","Spacing factor for step voltage,",16.5,"Ks","Factor de espaciado para la tensión de paso, ",16.5]
["Lc","Total length of grid conductor, m",14.3,"Lc","Longitud total del conductor de la malla, m ",14.3]
["LM","Effective length of Lc + LR for mesh",16.5,"LM","Longitud efectiva de Lc + LR para malla ",16.5]
["LR","Total length of ground rods, m",16.5,"LR","Longitud total de las barras de tierra, m ",16.5]
["Lr","Length of ground rod at each location, m","14.3, 16.5","Lr","Longitud de la barra de tierra en cada lugar, m ","14.3, 16.5"]
["LS","Effective length of L  + L  for step voltage, m","16.6","LS","Longitud efectiva de L + L para la tensión de paso, m ","16.6"]
["LT","Total effective length of grounding system conductor, including grid and ground rods, m","14.2","LT","Longitud efectiva total del conductor de puesta a tierra, incluyendo las barras de la malla y de tierra, m ","14.2"]
["Lx","Maximum length of grid conductor in x direction, m",16.5,"Lx","Longitud máxima del conductor de malla en la dirección x, m ",16.5]
["Ly","Maximum length of grid conductors in y direction, m",16.5,"Ly","Longitud máxima del conductor de la malla en dirección Y, m ",16.5]
["n","Geometric factor composed of factors na, nb, nc, and nd",16.5,"n","Factor geométrico compuesto por los factores: na, nb, nc y nd",16.5]
["nR","Number of rods placed in area A",14.3,"nR","Número de barras colocadas en la zona A ",14.3]
["Rg","Resistance of grounding system, Ω","14.1–14.4","Rg","Resistencia del sistema de puesta a tierra, Ω ","14.1–14.4"]
["Sf","Fault current division factor (split factor)","15.1.3","Sf","Factor de division de corriente de falla (factor de división) ","15.1.3"]
["tc","Duration of fault current for sizing ground conductor, s",11.3,"tc","Duración de la corriente de falla para el dimensionamiento del conductor de tierra, s ",11.3]
["tf","Duration of fault current for determining decrement factor, s",15.1,"tf","Duración de la corriente de falla para determinar el factor de decremento, s ",15.1]
["ts","Duration of shock for determining allowable body current, s","5.2–6.3","ts","Duración de shock para la determinación de la  corriente  permisible del cuerpo, s","5.2–6.3"]
[]
[]
[]
[]
[null,null,null,null,null,"Agradezco cualquier sugerencia para mejorar este programa"]
[null,null,null,null,null,"Gregor Rojas"]

{"sheet":"figuras","index":6,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,2,1,19],[30,1,30,21],[45,20,46,20],[62,3,62,13],[62,14,62,20],[32,3,32,20],[49,1,50,2],[33,2,44,2],[52,1,52,20],[31,1,31,21],[3,5,3,17],[4,4,15,4],[20,3,21,4],[2,3,2,18],[16,17,17,17],[82,1,82,20],[76,1,76,21],[61,1,61,21],[60,1,60,21],[69,21,74,21],[63,21,68,22],[63,2,74,2],[67,20,68,20],[79,1,80,2],[75,3,75,20]]}
[]
[null,null,"GEOMETRIA DE LA MALLA DE FORMA CUADRADA"]
[null,null,null,"FIGURA 1"]
[null,null,null,null,null,{"$f":"'Menu principal'!F20&\" m (a)\"","v":"5 m (a)"}]
[null,null,null,null,{"$f":"'Menu principal'!F21&\" m (b)\"","v":"5 m (b)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!$F$24&\" m\"","v":"1 m"}]
[null,null,null,null,null,null,null,null,null,null,null,"VISTA DE PLANTA",null,null,null,null,null,{"$f":"'Menu principal'!$F$24&\" m\"","v":"1 m"}]
[]
[]
[null,null,null,null,null,"Nivel del suelo"]
[null,null,null,{"$f":"'Menu principal'!$F$25&\" cm\"","v":"30 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!$F$11&\" cm\"","v":"5 cm"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"VISTA LATERAL"]
[]
[]
[]
[]
[]
[]
[]
[null,"GEOMETRIA DE LA MALLA DE FORMA RECTANGULAR"]
[null,"FIGURA 2"]
[null,null,null,{"$f":"'Menu principal'!F20&\" m (a)\"","v":"5 m (a)"}]
[null,null,{"$f":"'Menu principal'!F21&\" m (b)\"","v":"5 m (b)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!$F$24&\" m\"","v":"1 m"}]
[null,null,null,null,null,null,null,null,null,null,null,"VISTA DE PLANTA",null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!F24&\" m\"","v":"1 m"}]
[]
[]
[null,null,null,"Nivel del suelo"]
[null,{"$f":"'Menu principal'!$F$25&\" cm\"","v":"30 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!$F$11&\" cm\"","v":"5 cm"}]
[]
[]
[null,"VISTA LATERAL"]
[]
[]
[]
[]
[]
[]
[]
[null,"GEOMETRIA DE LA MALLA DE FORMA  \"L\""]
[null,"FIGURA 3"]
[null,null,null,{"$f":"'Menu principal'!F22&\" m (L1)\"","v":"3 m (L1)"}]
[null,null,{"$f":"'Menu principal'!F21&\" m (b)\"","v":"5 m (b)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!$F$24&\" m\"","v":"1 m"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!$F$24&\" m\"","v":"1 m"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!F23&\" m (L2)\"","v":"3 m (L2)"}]
[]
["Calculo malla PAT segu IEEE 80-2000"]
[]
[]
[]
[null,null,null,{"$f":"'Menu principal'!F20&\" m (a)\"","v":"5 m (a)"}]
[null,"VISTA DE PLANTA"]
[]
[null,null,null,"Nivel del suelo"]
[null,{"$f":"'Menu principal'!$F$25&\" cm\"","v":"30 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Menu principal'!$F$11&\" cm\"","v":"5 cm"}]
[]
[]
[null,"VISTA LATERAL"]

{"sheet":"materiales","index":7,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"CONDUCTOR DESNUDO",null,"CALIBRE","Kcmil","DIA","AREA","AMP"]
[2,"CBDES0100002","CABLE DESNUDO DE COBRE 2 AWG","2 AWG",66,7.42,33.619999999999997,175]
[3,"CBDES0100100","CABLE DESNUDO DE COBRE 1/0 AWG","1/0 AWG",106,9.4600000000000009,53.49,235]
[4,"CBDES0100200","CABLE DESNUDO DE COBRE 2/0 AWG","2/0 AWG",133,10.63,67.430000000000007,275]
[5,"CBDES0100300","CABLE DESNUDO DE COBRE 3/0 AWG","3/0 AWG",168,11.95,85,320]
[6,"CBDES0100400","CABLE DESNUDO DE COBRE 4/0 AWG","4/0 AWG",212,13.4,107.2,370]
[7,"CBDES0101250","CABLE DESNUDO DE COBRE 250 MCM","250Kcmil",250,14.63,126.7,410]
[8,"CBDES0101300","CABLE DESNUDO DE COBRE 300 MCM","300Kcmil",300,16,152,460]
[9,"CBDES0101350","CABLE DESNUDO DE COBRE 350 MCM","350Kcmil",350,17.29,177,510]
[10,"CBDES0100500","CABLE DESNUDO DE COBRE500 MCM","500Kcmil",500,20.7,253,630]
[null,"fuente ELECON"]
[]
[]
[1,"PTCE000015"," Kit/Soldadura exotermica 15 Grs"]
[2,"PTCE000025"," Kit/Soldadura exotermica 25 Grs"]
[3,"PTCE000032"," Kit/Soldadura exotermica 32 Grs"]
[4,"PTCE000045"," Kit/Soldadura exotermica 45 Grs"]
[5,"PTCE000065"," Kit/Soldadura exotermica 65 Grs"]
[6,"PTCE000090"," Kit/Soldadura exotermica 90 Grs"]
[7,"PTCE000115"," Kit/Soldadura exotermica 115 Grs"]
[8,"PTCE000150"," Kit/Soldadura exotermica 150 Grs"]
[9,"PTCE000200"," Kit/Soldadura exotermica 200 Grs"]
[10,"PTCE000250"," Kit/Soldadura exotermica 250 Grs"]
[null,"fuente GEDISA"]
[]
[]
[1,"PTXSH035035","MOLDE EQUIS CARTUCHO","2 AWG",null,90]
[2,"PTXSH050050","MOLDE EQUIS CARTUCHO","1/0 AWG",null,150]
[3,"PTXSH070070","MOLDE EQUIS CARTUCHO","2/0 AWG",null,200]
[4,"PTXSH095095","MOLDE EQUIS CARTUCHO","3/0 AWG",null,250]
[5,"PTXSH100100","MOLDE EQUIS CARTUCHO","4/0 AWG",null,250]
[6,"PTXSH120120","MOLDE EQUIS CARTUCHO","250Kcmil",null,"2X150"]
[7,"PTXSH150150","MOLDE EQUIS CARTUCHO","300Kcmil",null,"2X200"]
[8,"PTXSH185185","MOLDE EQUIS CARTUCHO","350Kcmil"]
[null,"PTXSH240240","MOLDE EQUIS CARTUCHO","500Kcmil"]
[]
[1,"PTCTH035035","MOLDE EQUIS CARTUCHO","2 AWG",null,32]
[2,"PTCTH050050","MOLDE EQUIS CARTUCHO","1/0 AWG",null,90]
[3,"PTCTH070070","MOLDE EQUIS CARTUCHO","2/0 AWG",null,90]
[4,"PTCTH095095","MOLDE EQUIS CARTUCHO","3/0 AWG",null,115]
[5,"PTCTH100100","MOLDE EQUIS CARTUCHO","4/0 AWG",null,150]
[6,"PTCTH120120","MOLDE EQUIS CARTUCHO","250Kcmil",null,150]
[7,"PTCTH150150","MOLDE EQUIS CARTUCHO","300Kcmil",null,200]
[8,"PTCTH185185","MOLDE EQUIS CARTUCHO","350Kcmil",null,200]
[null,"PTCTH240240","MOLDE EQUIS CARTUCHO","500Kcmil",null,"2X150"]
[null,"fuente GEDISA"]

{"sheet":"Instrucciones","index":8,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"PROGRAMA DE CÁLCULO DE LA MALLA DE PUESTA A TIERRA\n BASADO EN LA IEEE 80-2000 "]
[null,"INSTRUCTIVO DE USO DEL PROGRAMA"]
[1,"Asegúrese de que las MACROS estén habilitadas"]
[2,"En la parte denominada: DATOS PARA EL CÁLCULO DE LA MALLA DE PUESTA A TIERRA ingresar los datos del proyecto"]
[3,"Busque el valor de la  resistencia requerida según el tipo de proyecto en la casilla \"Resistencia requerida según aplicación menor a\" mediante la selección en lista desplegable para tal fin."]
[4,"Ajuste el valor de la resistividad del suelo en la casilla Resistividad aparente del terreno   (Ω.m) mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 10 hasta 20.000."]
[5,"Ajuste el valor de la corriente de falla If en la casilla Corriente de falla a tierra simétrica rms (A) mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 1000 a 60.000 "]
[6,"Ajuste el valor del tiempo de despeje de la falla tc en la casilla Tiempo de despeje de la falla (ms) mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 50 hasta 3.000."]
[7,"Si existe en su diseño una capa superficial  haga Crick sobre el recuadro en Marque la casilla si existe una capa superficial, deberá cambiar la indicación de \"NO\" a \"SÍ\""]
[8,"Ajuste el valor de la capa superficial ρs en la casilla Resistividad de la capa superficial  (Ω.m) Ver tabla 7 mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 100 hasta 60.000."]
[9,"Haga \"Crick\" en el botón \"Tabla 7 Pag. 52 IEEE 80-2000\" para que el programa lo traslade a la TABLA 7 y poder tomar referencias de los valores típicos para esta capa según el material que se seleccione"]
[10,"Ajuste el valor del espesor de la capa superficial hs en la casilla Espesor de la capa superficial hs (cm) mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 5 hasta 300. "]
[11,"En la parte denominada: CARACTERISTICAS DEL CONDUCTOR DE LA MALLA DE PAT seleccionar el tipo de conductor a utilizar en el proyecto."]
[12,"Busque el conductor  requerido para el proyecto en la casilla \"Tipo de conductor seleccionado\" mediante la selección en lista desplegable para tal fin. "]
[13,"Haga \"Crick\" en el botón \"Tabla 2 Pág.. 44 IEEE 80-2000\" para que el programa lo traslade a la TABLA 2 y poder tomar referencias de valores típicos para los distintos tipos de conductores"]
[14,"En base a los datos seleccionados el programa automáticamente calculará el calibre conductor a utilizar en la malla de puesta a tierra y le dará el código GEDISA del conductor."]
[15,"En la parte denominada: GEOMETRIA DE LA MALLA ingresar la forma y las dimensiones de los componentes de la malla"]
[16,"Elija la forma del diseño  de la malla haciendo Crick sobre el circulo para seleccionar: cuadrado, rectangular o en forma de L              "]
[17,"Ajuste el valor del largo de la forma elegida en la casilla correspondiente mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 5 hasta 500."]
[18,"Si selecciono la forma cuadrada el ajuste del ancho  en la casilla correspondiente se realizara de manera automática, no requiere ajuste."]
[19,"Si selecciono la forma rectangular el ajuste del ancho  en la casilla correspondiente será mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 5 hasta 500."]
[20,"Si selecciono la forma en L, el ajuste del ancho  en la casilla correspondiente será mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 5 hasta 500. Para ajustar los valores de las longitudes  L1 y L2 se procede de forma análoga."]
[21,"Ajuste los valores de la cuadricula en la casilla Longitud de los lados de la cuadrícula (m) mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 1 hasta 30"]
[22,"Haga \"Crick\" en el botón \"Ver figura X\" para que el programa lo traslade a la figura seleccionada y poder observar la conformación de la malla"]
[23,"Si su diseño contempla el empleo de barras copperweld  haga click sobre el recuadro de la casilla \"Empleo de Barras Copperweld\" segidamente aparecera la afirmación SI"]
[24,"Elija el modelo de barra copperweld que se ajusta a su proyecto en la casilla \"Modelo de barra copperweld\" mediante la selección en lista desplegable para tal fin. Automaticamente aparecera en la casilla \"Diámetro de la Barra Copperweld o jabalina (mm)\" el diametro correspondiente"]
[25,"Ajuste la longitud de la barra en la casilla \"Longitud de la Barra Copperweld o jabalina (m)\" mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 2,4 hasta 12"]
[26,"Coloque la cantidad de barras en la casilla \"Número de barras copperweld colocadas en el área A\" mediante el accionamiento de la barra de desplazamiento para tal fin que va desde 1 hasta 300"]
[27,"Realizados los pasos anteriores el programa calculara automáticamente  los otros parametros geometricos de la malla"]
[28,"El programa calculara automáticamente las cantidades de cartuchos soldadura exotermica necesarios para realizar las conexiones de la malla tanto para las TEE como las EQUIS y dara los códigos GEDISA que corresponden para estos materiales"]
[29,"Para obtener los  voltajes permisibles de paso y  toque en función del peso de una persona elija el peso  que se ajusta a su proyecto en la casilla \"Peso de la persona para estimación \" mediante la selección en lista desplegable para tal fin. Automaticamente el programa realizara los calculos de estos y de los voltajes reales o maximos. De igual forma realizara las comparaciones para indicarle si se debe realiuzar algun cambio o ajuste para que su diseño cumpla con la norma"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Agradezco cualquier sugerencia para mejorar este programa"]
[null,"Gregor Rojas"]